2013-03-21 - 5910.200 - Rel Notes - Contracts - Release 004 #BIReleases2013

Release Notes:

5910.200 - Contracts - OSA350

Admin Info

Purpose
 Including Contract Information in OSA350 report
Release No
 004
Submitted
 03-21-2013
Submitted by
 Mallareddy D
Source/Destination Systems
 IT > BMS > Quality > Contracts to IT > BMS > Production > Contracts in SAP BO BI 4.0 Dev Environment
Release Sent To
 Mark Harris
Object(s) Created By
 Mallareddy D
Object(s) Tested By
 Narendra K

Report Name

OSA350 - Open Orders for Hot Market

BEx Query

ZMP_OPASA_Q032

NEC Crystal Reports Standards Check

1. OSA350 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. OSA350 NEC CR checklist has been sent to NEC and also attached here for reference.
OSA350 NEC CR Standard Check List.xlsx

Dynamic Group 1:

Test Conducted

Group: Sales Org > License > Season > Collection > Material > Customer

Summary Level Check

Test Conducted

Group: EMEA Sales
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 1,413,873
 1,413,873
 Pass
2
 Value
 19,966,875.89
 19,966,834.97
 Pass
Note: In value, difference between CR and BEx value is $40, considered as successfully validated.

Group: United States Sales
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 26,516
 26,516
 Pass
2
 Value
 297,729.14
 297,729.14
 Pass

Second Level Check

Test Conducted

Group: EMEA Sales > MLB Properties
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 872,043
 872,043
 Pass
2
 Value
 12,286,439.73
 12,286,411.78
 Pass
Note: In value, difference between CR and BEx value is $28, considered as successfully validated.

Group: United States Sales > COLLEGIATE LICENSING
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 222,044
 222,044
 Pass
2
 Value
 2,273,447.54
 2,273,447.54
 Pass

Third Level Check

Test Conducted

Group: EMEA Sales > MLB Properties > Custom
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 195,734
 195,734
 Pass
2
 Value
 2,486,467.64
 2,486,467.67
 Pass
Group: United States Sales > COLLEGIATE LICENSING > COLL FALL 1 - 7 15 13
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 87,605
 87,605
 Pass
2
 Value
 849,721.24
 849,721.24
 Pass

Fourth Level Check

Test Conducted

Group: EMEA Sales > MLB Properties > Custom > CUSTOM
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 195,626
 195,626
 Pass
2
 Value
 2,483,994.43
 2,483,994.43
 Pass
Group: United States Sales > COLLEGIATE LICENSING > COLL FALL 1 - 7 15 13 -> Blitz Neo
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 3,282
 3,282
 Pass
2
 Value
 32,211.70
 32,211.70
 Pass

Fifth Level Check

Test Conducted

Group: EMEA Sales > MLB Properties > Custom > CUSTOM > 8 PANEL LINENMILBRECO DK GREE/WHITE

SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 144
 144
 Pass
2
 Value
 2,833.51
 2,833.51
 Pass
Group: United States Sales > COLLEGIATE LICENSING > COLL FALL 1 - 7 15 13 > Blitz Neo > BLITZ NEO CLETIG WHT/GRY
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 191
 191
 Pass
2
 Value
 1,898.8
 1,898.8
 Pass

Sixth Level Check

Test Conducted

Group: EMEA Sales > MLB Properties > Custom > CUSTOM > 8 PANEL LINENMILBRECO DK GREE/WHITE > John David Group
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 144
 144
 Pass
2
 Value
 2,833.51
 2,833.51
 Pass
Group: United States Sales > COLLEGIATE LICENSING > COLL FALL 1 - 7 15 13 > Blitz Neo > BLITZ NEO CLETIG WHT/GRY > TIGER SPORTS SHOP INC
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 96
 96
 Pass
2
 Value
 938.88
 938.88
 Pass

Dynamic Group 2:

Test Conducted

Sales Org > License > Season > Team

Summary Level Check

Test Conducted

Group: APAC Sales
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 41353
 41353
 Pass
2
 Value
 572,025.32
 572,025.32
 Pass
Group: Australia Sales
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 20,878
 20,878
 Pass
2
 Value
 413034.59
 413034.73
 Pass

Second Level Check

Test Conducted

Group: APAC Sales > NATIONAL RUGBYLEAGUE
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 3,121
 3,121
 Pass
2
 Value
 43,558.82
 43,558.82
 Pass
Group: Australia Sales > NFL PROPERTIES
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 2,920
 2,920
 Pass
2
 Value
 59,996.13
 59,996.10
 Pass

Third Level Check

Test Conducted

Group: APAC Sales > NATIONAL RUGBYLEAGUE > Custom
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 3,121
 3,121
 Pass
2
 Value
 43,558.82
 43,558.82
 Pass
Group: Australia Sales > NFL PROPERTIES > SUMMER 2 - Apr 8 13
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 39
 39
 Pass
2
 Value
 912.98
 912.98
 Pass

Fourth Level Check

Test Conducted

Group: APAC Sales > NATIONAL RUGBYLEAGUE > Custom > WESTS TIGERS
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 392
 392
 Pass
2
 Value
 5,160.86
 5,160.86
 Pass
Group: Australia Sales > NFL PROPERTIES > SUMMER 2 - Apr 8 13 > OAKLAND RAIDERSS
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 9
 9
 Pass
2
 Value
 193.66
 193.66
 Pass

Dynamic Group 3:

Test Conducted

Sales Org > License > Season > Customer

Summary Level Check

Test Conducted

Group: Canada Sales
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 341,187
 341,187
 Pass
2
 Value
 4,475,325.25
 4,475,326.07
 Pass
Note: In value, difference between CR and BEx value is $1, considered as successfully validated.

Group: Latin America Sales
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 48,809
 48,809
 Pass
2
 Value
 582,306.78
 582,306.78
 Pass

Second Level Check

Test Conducted

Group: Canada Sales > CANADIAN FOOTBALL LEAGUE
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 33,722
 33,722
 Pass
2
 Value
 392,287.55
 392,287.45
 Pass
Group: Latin America Sales > DISNEY
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 3047
 3047
 Pass
2
 Value
 2,702.40
 2,702.40
 Pass

Third Level Check

Test Conducted

Group: Canada Sales > CANADIAN FOOTBALL LEAGUE > CFL SPR13 MAY 13 13
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 32,791
 32,791
 Pass
2
 Value
 382,189.20
 382,189.25
 Pass
Group: Latin America Sales > DISNEY > Summer 2 - Apr 8 13
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 48
 48
 Pass
2
 Value
 384.00
 384.00
 Pass

Fourth Level Check

Test Conducted

Group: Canada Sales > CANADIAN FOOTBALL LEAGUE > CFL SPR13 MAY 13 13 > TIME OUT SPORTS INC
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 12
 12
 Pass
2
 Value
 151.25
 151.25
 Pass
Group: Latin America Sales > DISNEY > Summer 2 - Apr 8 13 > DANIEL GARCIA
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 48
 48
 Pass
2
 Value
 384.00
 384.00
 Pass

Dynamic Group 4:

Test Conducted

Sales Org > License > Season > Collection > Sales Rep > Customer

Summary Level Check

Test Conducted

Group: Mexico Sales
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 10,232
 10,232
 Pass
2
 Value
 105,732.93
 105733.93
 Pass
Note: In value, difference between CR and BEx value is $1, considered as successfully validated.

Group: NEC Korea Sales
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 1,151
 1,151
 Pass
2
 Value
 22,563.54
 22,563.54
 Pass

Second Level Check

Test Conducted

Group: Mexico Sales > MLB PROPERTIES
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 1559
 1559
 Pass
2
 Value
 24,275.35
 24,275.37
 Pass
Group: NEC Korea Sales > NEW ERA BRANDED
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 45
 45
 Pass
2
 Value
 502.56
 502.56
 Pass

Third Level Check

Test Conducted

Group: Mexico Sales > MLB PROPERTIES > Stock
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 907
 907
 Pass
2
 Value
 12,896.30
 12,896.31
 Pass
Group: NEC Korea Sales > NEW ERA BRANDED > LIF FALL 1 - 6 17 13
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 45
 45
 Pass
2
 Value
 502.56
 502.56
 Pass

Fourth Level Check

Test Conducted

Group: Mexico Sales > MLB PROPERTIES > Stock > AC PERFORMANCE
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 359
 359
 Pass
2
 Value
 6,500.84
 6,500.84
 Pass
Group: NEC Korea Sales > NEW ERA BRANDED > LIF FALL 1 - 6 17 13 > BASIC CANVAS BELT 2
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 30
 30
 Pass
2
 Value
 335.04
 335.04
 Pass

Fifth Level Check

Test Conducted

Group: Mexico Sales > MLB PROPERTIES > Stock > AC PERFORMANCE >Alex Noguera
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 359
 359
 Pass
2
 Value
 6,500.84
 6,500.84
 Pass
Group: NEC Korea Sales > NEW ERA BRANDED >LIF FALL 1 - 6 17 13 > BASIC CANVAS BELT 2 > John Song
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 30
 30
 Pass
2
 Value
 335.04
 335.04
 Pass

Sixth Level Check

Test Conducted

Group: Mexico Sales > MLB PROPERTIES > Stock > AC PERFORMANCE > Alex Noguera > NEW ERA CAP MEXICO CATEGORY
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 7
 7
 Pass
2
 Value
 23.73
 23.71
 Pass
Group: NEC Korea Sales > NEW ERA BRANDED > LIF FALL 1 - 6 17 13 > BASIC CANVAS BELT 2 > John Song > LAB
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 30
 30
 Pass
2
 Value
 335.04
 335.04
 Pass

Reference Document (Specification)

2013-03-15 - 5910.200 - Spec - Contract Reports